import pandas as pd
from sqlalchemy import text

from database.mysql_utils import MysqlConnect


def get_select_country_store_id():
    """ 获取美国、英国、德国的所有店铺id
    """
    engine_rpa = MysqlConnect.mysql_connect()
    get_country_sql = text("""
    select
        distinct sid,country
    from store
    where name not like '%转让%'
    """)
    store_id_df = pd.read_sql(get_country_sql,engine_rpa)
    return store_id_df







